package cn.lanqiao.bigDate.mapper.data;

import cn.lanqiao.bigDate.entity.data.DataPbhouse;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


@Mapper
public interface DataPbhouseOrderMapper extends BaseMapper<DataPbhouse> {
    /**
     * 查找综合热度前九的出版社的name与popular
     * @param date
     * @return
     */
    @Select("SELECT id,pbhouse_name,popular FROM `data_pbhouse` ORDER BY popular DESC LIMIT 9")
    List<Map<String,String>> findPbhouseOrderData(String date);
}
